Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
OutboundTenderRepository (FK) | The unique identifier for the TENDER RESPOSITORY. | ID_OTB_TND_RPSTY | Identity | integer | Safe(AS_SF) |
InboundTenderRepositoryID (FK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND_TO | Identity | integer | ExternalDepository(LO_EXTDST) |
Depositing (FK) | A unique system-assigned identifier for the Person who made this TenderDeposit. | ID_WRKR_DS | Identity | integer | Worker(PA_WRKR) |
DepositBagID | A unique identifier for the Deposit Bag that was used to transport the Tender from the Safe to the ExternalDepository. | ID_BG_DS | Identity | integer | |
Description | A shor narrative description of the DepositTransaction. | DE_DS | DescriptionShort | varchar(255) | |
Amount | The total monetary value (in the default system currency) of all TenderLineItems in this DepositTransaction. | MO_DS | MoneyShortRetail | decimal(7,2) | |
ForeignCurrencyAmount | The total monetary value (in the currency being deposited) of all TenderLineItems in this DepositTransaction. | MO_DS_FRG_CY | MoneyShortRetail | decimal(7,2) | |
OverAmount | The total monetary value (in the default system currency) that was over the recorded amount when the deposit bag was checked at the ExternalDepository. | MO_OVR | MoneyShortRetail | decimal(7,2) | |
OverForeignCurrencyAmount | The total monetary value (in the currency being deposited) that was over the recorded amount when the deposit bag was checked at the ExternalDepository. | MO_OVR_FRG_CY | MoneyShortRetail | decimal(7,2) | |
ShortAmount | The total monetary value (in the default system currency) that was under the recorded amount when the deposit bag was checked at the ExternalDepository. | MO_SHRT | MoneyShortRetail | decimal(7,2) | |
ShortForeignCurrencyAmount | The total monetary value (in the currency being deposited) that was under the recorded amount when the deposit bag was checked at the ExternalDepository. | MO_SHRT_FRG_CY | MoneyShortRetail | decimal(7,2) | |
SafeTenderMovementCode | A code that indicates the movement of tender with respect to a SAFE. It is used to clarify whether tender is being RECEIVED into a store safe from an external repository or DEPOSITED from a safe into an external depository. Valid values: RECEIPT - inbound from external dep. to safe DEPOSIT - outbound from safe to ext dep. | CD_SF_TND__MV | Code | varchar(20) | |